CREATE TABLE [dbo].[CCAuthAcct]
(
[CCAuthAcctCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthAcctCode] DEFAULT (''),
[CCAuthAcctDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthAcctDescription] DEFAULT (''),
[CCAuthMode] [tinyint] NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthMode] DEFAULT ((0)),
[CCAuthAdminEmail] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthAdminEmail] DEFAULT (''),
[CCAuthURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthURL] DEFAULT (''),
[CCAuthGateway] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthGateway] DEFAULT (''),
[CCAuthPort] [int] NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthPort] DEFAULT ((0)),
[CCAuthUser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthUser] DEFAULT (''),
[CCAuthPassword] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthPassword] DEFAULT (''),
[CCAuthVerisignPartner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignPartner] DEFAULT (''),
[CCAuthVerisignVendor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignVendor] DEFAULT (''),
[CCAuthTimeout] [int] NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthTimeout] DEFAULT ((0)),
[CCAuthVerisignProxyServer] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignProxyServer] DEFAULT (''),
[CCAuthVerisignProxyPort] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignProxyPort] DEFAULT (''),
[CCAuthVerisignProxyUser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignProxyUser] DEFAULT (''),
[CCAuthVerisignProxyPassword] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVerisignProxyPassword] DEFAULT (''),
[CCAuthVoidURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthVoidURL] DEFAULT (''),
[CCAuthReturnURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthReturnURL] DEFAULT (''),
[CCAuthQueryURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthQueryURL] DEFAULT (''),
[CCAuthCaptureURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthCaptureURL] DEFAULT (''),
[CCAuthConfPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthConfPath] DEFAULT (''),
[CCAuthSaveCscBeforeAuth] [tinyint] NOT NULL CONSTRAINT [DF_CCAuthAcct_CCAuthSaveCscBeforeAuth] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CCAuthAcct] ADD CONSTRAINT [PK_CCAuthAcct] PRIMARY KEY CLUSTERED ([CCAuthAcctCode]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[CCAuthAcct] TO [IMIS]
GRANT SELECT ON  [dbo].[CCAuthAcct] TO [IMIS]
GRANT INSERT ON  [dbo].[CCAuthAcct] TO [IMIS]
GRANT DELETE ON  [dbo].[CCAuthAcct] TO [IMIS]
GRANT UPDATE ON  [dbo].[CCAuthAcct] TO [IMIS]
GO